Show All
Change the amount of detail displayed in a PivotChart report
Determine what kind of source data your report has: click the report, if the field list is not displayed click Show Field List
on the PivotTable
toolbar, and look at the PivotTable Field List window.
-
If the field list has
and
icons, the report has OLAP source data.
-
If the field list has
icons, the report does not have OLAP source data.
For OLAP reports, do one or more of the following:
Display or hide different levels of detail for a field
- Click the associated PivotTable report for the PivotChart report.
- Click the field.
- To display or hide lower-level detail, click Show Detail
or Hide Detail
on the PivotTable toolbar.
-
To hide upper levels of detail, right-click the field button for the lowest level you want to hide, and then click Hide levels on the shortcut menu.
The level you clicked and all higher levels in the dimension are removed from view, and the dropdown arrow
is also hidden.
To redisplay hidden upper levels, right-click any field button in the dimension, and then click Show levels on the shortcut menu.
Note If you hide and then redisplay levels, any renamed items revert to their original names.
Display or hide property fields
- Click the associated PivotTable report for the PivotChart report.
- Click the field for which you want to display property fields.
- On the PivotTable toolbar, click PivotTable, and then click Property Fields.
- In the Choose properties from level list, click each level for which you want to display property fields, and then double-click the property fields you want to see.
- In the Properties to display box, use the
and
buttons to arrange the property fields in the order you want them to appear in the report.
- Make sure the Show fields for this dimension in outline form check box is selected, and then click OK.
- If the levels for which you selected property fields aren't displayed in the report, click the field and then click Show Detail
on the PivotTable toolbar.
For non-OLAP reports, do one or more of the following:
Display or hide series detail
- Click the associated PivotTable report for the PivotChart report.
- Click the column field for the series for which you want to show or hide detail.
- On the PivotTable toolbar, click Show Detail
or Hide Detail
.
- If prompted, double-click the field that has the detail you want to show.
Display or hide category item detail
- Right-click the category label for which you want to show or hide detail, or in a pie or doughnut chart, click the slice or ring for which you want to show or hide detail.
- On the shortcut menu, click Show detail category name or Hide detail category name.
- If prompted, double-click the field that has the detail you want to show.
Note When you change the amount of detail displayed in a PivotChart report, some chart formatting may be lost.